Papers with retrieve-then-generate framework
Gen-SQL: Efficient Text-to-SQL By Bridging Natural Language Question And Database Schema With Pseudo-Schema (2025.coling-main)
Copied to clipboard
| Challenge: | Recent studies have shifted paradigms and leveraged Large Language Models (LLMs) to tackle the challenging task of Text-to-SQL. |
| Approach: | They propose a framework that leverages large language models to generate SQL queries . they exploit prior knowledge from the LLM to enhance embedding-based retriever . |
| Outcome: | The proposed method improves embedding-based retriever and reduces cost. |
Bidirectional Semantic Enhancement for Schema Routing Across Large-Scale Databases (2026.findings-acl)
Copied to clipboard
| Challenge: | Existing methods relying on unidirectional query expansion fail to bridge lexical mismatches and graph-based approaches struggle to navigate schemas when explicit structural links are missing. |
| Approach: | They propose a retrieval framework that bridges the semantic gap between user queries and vague schema definitions by performing online generative query expansion. |
| Outcome: | The proposed retrieval framework bridges the semantic gap between user queries and vague schema definitions by enriching table schemas offline and performing online generative query expansion. |